Tabela CO_ORDER

Definicja tabeli CO_ORDER

Name

CO_ORDER

Code

CO_ORDER

Comment

 


Lista kolumn tabeli CO_ORDER

Name

Code

ORDERID

ORDERID

ORDERNO

ORDERNO

LOCATIONID

LOCATIONID

ORDERDT

ORDERDT

DELIVERYDT

DELIVERYDT

KITCHENID

KITCHENID

CORRECTED

CORRECTED

CORRECTIONFOR

CORRECTIONFOR

INFO

INFO

ACTIVE

ACTIVE

INSERTDT

INSERTDT

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

INSERTDATE

INSERTDATE

OrderTypeId

OrderTypeId

ORDERSTATUSID

ORDERSTATUSID


Kolumna ORDERID tabeli CO_ORDER

Definicja kolumny ORDERID tabeli CO_ORDER

Name

ORDERID

Code

ORDERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ORDERNO tabeli CO_ORDER

Definicja kolumny ORDERNO tabeli CO_ORDER

Name

ORDERNO

Code

ORDERNO

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna LOCATIONID tabeli CO_ORDER

Definicja kolumny LOCATIONID tabeli CO_ORDER

Name

LOCATIONID

Code

LOCATIONID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ORDERDT tabeli CO_ORDER

Definicja kolumny ORDERDT tabeli CO_ORDER

Name

ORDERDT

Code

ORDERDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna DELIVERYDT tabeli CO_ORDER

Definicja kolumny DELIVERYDT tabeli CO_ORDER

Name

DELIVERYDT

Code

DELIVERYDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna KITCHENID tabeli CO_ORDER

Definicja kolumny KITCHENID tabeli CO_ORDER

Name

KITCHENID

Code

KITCHENID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CORRECTED tabeli CO_ORDER

Definicja kolumny CORRECTED tabeli CO_ORDER

Name

CORRECTED

Code

CORRECTED

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CORRECTIONFOR tabeli CO_ORDER

Definicja kolumny CORRECTIONFOR tabeli CO_ORDER

Name

CORRECTIONFOR

Code

CORRECTIONFOR

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna INFO tabeli CO_ORDER

Definicja kolumny INFO tabeli CO_ORDER

Name

INFO

Code

INFO

Data Type

VARCHAR2(1020)

Mandatory

No

Comment

 


Kolumna ACTIVE tabeli CO_ORDER

Definicja kolumny ACTIVE tabeli CO_ORDER

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna INSERTDT tabeli CO_ORDER

Definicja kolumny INSERTDT tabeli CO_ORDER

Name

INSERTDT

Code

INSERTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_ORDER

Definicja kolumny INSERTINGPERSON tabeli CO_ORDER

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_ORDER

Definicja kolumny LASTMODIFIEDDT tabeli CO_ORDER

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_ORDER

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_ORDER

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna INSERTDATE tabeli CO_ORDER

Definicja kolumny INSERTDATE tabeli CO_ORDER

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna OrderTypeId tabeli CO_ORDER

Definicja kolumny OrderTypeId tabeli CO_ORDER

Name

OrderTypeId

Code

OrderTypeId

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ORDERSTATUSID tabeli CO_ORDER

Definicja kolumny ORDERSTATUSID tabeli CO_ORDER

Name

ORDERSTATUSID

Code

ORDERSTATUSID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli CO_ORDER

Name

Code

Primary

PK_CO_ORDER

PK_CO_ORDER

X


Klucz PK_CO_ORDER tabeli CO_ORDER

Definicja klucza PK_CO_ORDER tabeli CO_ORDER

Name

PK_CO_ORDER

Code

PK_CO_ORDER

Primary

Yes

Comment